Formatting Document
Hello, if anybody can help me please.
I have sheet in excel I received which looks like cells marked with 1, I'm looking for a way to make it look like to, so basically the task gets repeated down until task 2 starts then it does the same for task 2, the table marked as 3 would be great if that's even possible.
excel query.PNG
Thank you in advance
From the small amount of data you have proided, you are implying that
every Task has FOUR and ONLY FOUR rows below it.
Is that correct?
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hello, unfortunately not
the rows for each task can vary total sheet contains 2000 plus rows, some tasks might have 2-4 others might have 15
In that case a formula would be difficult, shame, cos I think I had a formula solution.
prob VBA or possibly Power Query but I'm no expert on these methods.
This can be done with PowerQuery - please provide a workbook.
Please do not open duplicate threads: if you want a thread moving, please contact a moderator.
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Hello, Sorry about that.
Here is workbook
Attachment 638339
Could you provide some rather more realistic sample data? Any solution I offer using what you have provided in the workbook is likely to fail when used with the real data. It needs to be as realistic as possible, but desensitised.
As before, simple VBA.
I did think of Power Query, but yours is not a structured table, and Power Query insists on that, and you would have to mess about with headers. VBA seemed simpler.
Please Login or Register to view this content.
Please see this file,
Attachment 638467
That's the same as post #6.
As you don't seem willing to provide more realistic data, I'm out. I hope you find a solution. Good luck!
Did you try my code?Originally Posted by oliverhhh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks