Hi All,
I have been manually doing this with the transpose function but I still have to paste each transposed column into a single vertical column and it is taking a very long time. Is there a shortcut for this? Sheet 1 is the original data and Sheet 3 is what I have done manually.
Thanks so much for the help. I have attached the spreadsheet.
Last edited by ExcelNeverQuit; 08-21-2015 at 07:33 AM.
Hello and good morn
your expected results doesn't match with your raw data..I cant see the year column anywhere..and one more thing if you want to transpose the whole one row to column you can do it with Start by selecting and copying your entire data range. Click on a new location in your sheet, then go to Edit | Paste Special and select the Transpose check box, as shown in Figure B. Click OK.
Regards
Jaya
Took formulas this far. Adapt for remaining columns.
I inserted duplicate Sample sheet for comparison.
First formula entered in A2 filled down and across to column D.Adapt the INDEX ranges and the MOD arguments for the remaining columns.Formula:
Please Login or Register to view this content.
Second formula generates repeating years. Enter in E2 and fill down.Formula:Please Login or Register to view this content.
Third formula grabs the sales. In F2 and fill down.Formula:Please Login or Register to view this content.
I didn't fill the formulas all the way down. The file would be too large to upload. The range is preselected in the saved file. You should just be able to press and hold Ctrl while hitting D (the keyboard shortcut for fill down.) The formulas will copy down.
The workbook is attached.
Dave
Wow, it works! Thank you so much Flame, I am very grateful. You saved me a few days if I had to manually do this!
You are welcome. Glad to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks