Related Posts
Dress code in TCS is formals all day week ?
Additional Posts in Excel Genius
I truly appreciate this group.

New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
Dress code in TCS is formals all day week ?
I truly appreciate this group.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Download the Fishbowl app to unlock all discussions on Fishbowl.
Copy and paste embed code on your site
Scan your QR code to download
Fishbowl app on your mobile
Use Power Query delimiter function to break the columns apart first. Then use Power Query to Unpivot your columns so it would be in rows.
Awesome! Glad that worked out.
Is the example in column B a single cell or two cells with a blank boundary? You might be able to do a LEFT(B3,FIND(“[press Alt-Enter here to insert a return character]”,B3)-1); similar with RIGHT(...) to get the second value.
Then once you have all the values in different columns, unpivot and fill the blanks.
Do text to columns and then transpose paste? Then do an of formula to fill in the blank rows on tge left.
Do another column and put in a formula to fill out your missing cells in column A? If(cell=0 or isblank, cell above it, if not return that cell)
Unmerge and then do this to copy the above value in the row below? Only works if values are infact above and blanks below.
https://www.myexcelonline.com/blog/copy-the-cell-above-in-excel/
To be clear, none of the cells are merged. They're separated by Alt+Enter in a single cell - so there's nothing to unmerge