I have data on a row like so:
A6 | B6 | C6 | D6 | E6 | F6 | G6 | H6|
xxx|yyy|-----|----| zzz|-----|aaa|-----|
(whereas the values below are in the above cell)
I would like the following result, ignoring all blanks on the row, from I6 onwards:
I6 | J6 | K6 | L6 | M6 | N6 | O6 | P6 |
xxx|yyy|zzz | aaa|----|----|----|----|
I have created a sheet for your reference.
Many thanks,
Danny
Here is a possibility with an extra empty column and a helper row under the original data.
1. Create an empty column at the beginning
2. Create a helper row under the original data. Try in B7 and copy to the right3. De formula with desired result: Try in J7 and copy to the right :Formula:
Please Login or Register to view this content.Formula:Please Login or Register to view this content.
Last edited by HansDouwe; 09-05-2022 at 12:41 AM.
I6=IFERROR(INDEX($A6:$H6,SMALL(IF($A6:$H6<>"",COLUMN($A6:$H6)-COLUMN($A6)+1,""),COLUMNS($A6:A6))),""), Ctrl+Shift+Enter to enter formula. Copy across.
Last edited by josephteh; 09-05-2022 at 01:16 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks