I'm trying to find a way to transpose some data that i have but the data is grouped together every 4 rows. instead of transposing the entire data set and copying and pasting it underneath each other, is there a faster way? I attached an Excel file of an example of the raw data which is originally broken down by day of week and the categories i need below each day. In the second sheet is the example of how i need the data broken down. Thanks for the help!
In sheet 2, A2, copied across and down:
=IFERROR(INDEX(Sheet1!$B$2:$O$37,COLUMNS($A:A)-1+4*INT((ROWS($1:1)-1)/14)+1,MOD(ROWS($1:1)-1,14)+1),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks