How to move numerous sets of data from columns to rows within a table?

**Rob8489** · 02-26-2012, 12:08 AM

Hi there

Aside from the "Paste Special's" TRANSPOSE checKbox, im not sure what other functions there are on excel that can solve this small issue of mine.

Ive attached the file with the original issue and the ideal scenario.

Any assistance would be greatly appreciated

Cheers
Rob

**DGagnon** · 02-26-2012, 03:58 AM

you could do something like this assuming that the table is sorted by Column B. requires a count on row 1 above the transposed table, but once you have the transposed data you can paste values and delete it.

=IF(COUNTIF($B:$B,$G2)>H$1,INDIRECT("C"&MATCH($G2,$B:$B,0)+H$1),"")