Hi all,
Could someone help me to find a solution to my problem?
i have a column of data and i want to transform them to a table as in the attached file.
i want to transform by formula in order to use as a template, so whenever i paste data the table can be created?
Please your help! it will be hihgly appreciated.
thank you in advance
Hi and welcome to the forum!
Will the data to be reproduced always be in groups of precisely 9 rows?
Regards
yes, exactly!!!
thank you
Hi,
Based on your attachment, enter this formula in C1 and copy across and down:
=IF(OR(COLUMNS($A:A)>9,ROWS($1:1)>COUNTA($A:$A)/9),"",INDEX($A:$A,COLUMNS($A:A)+9*(ROWS($1:1)-1)))
Regards
thank you very much!
best regards
You're welcome.
If you put the following formulas in cells C1, D1, E1, F1......K1
=INDIRECT("A"&(ROW()*9)-8), =INDIRECT("A"&(ROW()*9)-7), =INDIRECT("A"&(ROW()*9)-6),.......=INDIRECT("A"&(ROW()*9))
This puts each of the first 9 values in the top row of cells. Copy the formula down as far as needed, and it arranges your single column into 9 columns.
Hope this helps....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks