Macro to rearrange data in excel- merge 3 cells and move sheets

Closed
masayaanglibre Posts 2 Registration date Wednesday September 16, 2015 Status Member Last seen September 16, 2015 - Sep 16, 2015 at 03:21 PM
I am just starting to use macros and am lost on figuring this out.
Inventory comes in a 9x9 box with position 1,1 (rows, columns) in the bottom left
I have an inventory spreadsheet I get in that has 4 columns of pertinent info. Column D,G and M all have info I need to combine and place in a cell location based upon column 14. Preferably the data would be formatted to have each of the 3 original cell data on a new line within the new cell.


Sample Input


Sample Output