Format Excel

Define 'more fit'. More fit in what way? What do you need to do with it that you can't in its current format? Tell us what you want and we'll help you get there.

I wanted to remove the blanks if possible and unmerge the cells. Should be more organized.

There are multiple approaches to achieve the desired outcome, with one method utilizing helper columns. The resulting data is displayed in the 'After' sheet.

While it's feasible to accomplish the task without using helper columns, doing so often entails employing complex and resource-intensive formulas.

Alternatively, VBA (Visual Basic for Applications) could provide another avenue to accomplish the task.

I've provided a solution in the attachment, which utilizes formulas with helper columns. Please let me know if you prefer a VBA solution instead.

Should be more organized.

Are you looking for a normalised flat-file layout?

Administrative Note:

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #2 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...eport.htmllink

Thread closed.