Hi I am back and need a little help with reorganizing data. I could probably use a macro, but it would be good to automatically have the data realigned in real time. I have attached an excel of what I am talking about.
Hi I am back and need a little help with reorganizing data. I could probably use a macro, but it would be good to automatically have the data realigned in real time. I have attached an excel of what I am talking about.
One way:
Formula:Please Login or Register to view this content.
Lá fhéile Pádraig sona dhuit!
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
I should have added that the formula is happy to deal with longer ranges, including blank rows (to allow for extra data)... just don't go mad and add 000s of rows if you only need 00s. Just adjust sub-formula B:
=LET(A,A4:G4,B,A5:G20,
C,FILTER(B,....
It seems that you've had a look at my suggestion. Did it work for you?
Another way.
Formula:Please Login or Register to view this content.
Mixing Glenn and my proposal.
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks