LinkBack URL
About LinkBacks
Hi,
I have a dataset with data in rows, each row has multiple items separated by CHAR(10).
Im trying to get a dynamic solution to rearrange this dataset to show each line separately for each item in the row.
Attached sheet with desired results.
Hi,
I have a dataset with data in rows, each row has multiple items separated by CHAR(10).
Im trying to get a dynamic solution to rearrange this dataset to show each line separately for each item in the row.
Attached sheet with desired results.
Done..
Formula:
Please Login or Register to view this content.
It took some VB code to make it happen. The code is commented as to where you have to make changes to fit the final product.
Basically, the code uses the SPLIT command in VB to sort the parts into an array and then prints one row per array part.
Please Login or Register to view this content.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Another way,
Please Login or Register to view this content.
Elaborating on Windknife's formula, here is a shorter formula:
Please try:Please Login or Register to view this content.
Hi All
Thanks for the solutions
In my dataset there are some empty cells, so the formula is failing
Could you amend the formula to consider empty cells in between
Try this,
Please Login or Register to view this content.
That worked.
Thanks windknife!
You are welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks