DUMBPOLECopper ContributorJan 21, 2020EXCEL I WANT TO TRANSPOSE RECORDS IN A SINGLE COLUMN TO BE IN ROWS IN EXCEL EACH RECORD IS 15 ROWS LONG I HAVE DONE THE FIRST 3 IN MY DEMO FILE I DO NOT WANT TO DO THEM ONE AT A TIME !!!! ITS TO TEDIOUS...Show MoreAAAGOTIT.xls59 KB
DUMBPOLECopper ContributorJan 21, 2020DUMBPOLE Thank you for your quick reply and effortsI am going with:=IF(MOD(ROW(),15)=1,OFFSET($A1,COLUMN()-2,0),"")It works !!!!Fill the formula over to fill 15 columns, and then down to cover your 840 rows
