Hi Guys. Hope you are all well.
I need assistance in formatting this excel workbook sample file, to make it more fit once I copy and paste the data. Any ways can be helpful. Thanks a lot. If you can make it simple it would be better.
Hi Guys. Hope you are all well.
I need assistance in formatting this excel workbook sample file, to make it more fit once I copy and paste the data. Any ways can be helpful. Thanks a lot. If you can make it simple it would be better.
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.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I wanted to remove the blanks if possible and unmerge the cells. Should be more organized.
Last edited by thealndyn; 03-21-2024 at 02:19 AM.
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.
Quang PT
Are you looking for a normalised flat-file layout?Should be more organized.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks