Forum Discussion
Formula for vertical to horizontal data
I have data in E2-E1044 of Sheet 5 that I want to display in Sheet 1, shown below. The data may change, so I want to show the cell rather than just copy and paste current cell contents. The data sho...
Enter the following formula in E2:
=INDEX(Sheet5!$E:$E,(ROW()-ROW($E$2))*7+COLUMN()-COLUMN($E$2)+2)
Fill to the right to K2, then fill down.