Hi,
I need to rearrange the data based on their group. Attached herewith is the sample ws of input and output that I want to achieve. Hope someone could help me on this matter.
Thanks all.
Hi,
I need to rearrange the data based on their group. Attached herewith is the sample ws of input and output that I want to achieve. Hope someone could help me on this matter.
Thanks all.
Hi,
Anyone can help me here?
Please set your workbook up with more descriptive data. You may well understand the layout but for those of us, looking on, the use of "x" has no value that we can use to judge the process required.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Hi
Pls find attached file. FYI I have 180 sheets to cleanup.
The output as in Row 40 and further.
As I now understand it, you wish to compress data for each grouping ID as found in Column A, by moving each cell of data upwards in each column until no blank cells are found. Is this right?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
There are some formatting issues here as well. Am I right to assume that you require all cells to be formatted as;
Horizontal (Left Indent), Indent (0), Vertical (Top), Text Control (Wrap Text), Right To Left (Context).
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
yes you're right.Originally Posted by Aussiebear
YesOriginally Posted by Aussiebear
Hmmmm.... and columns O & S do not reflect this wish.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
I put dummy figure in that column. Does it sounds ok?Originally Posted by Aussiebear
Pls refer to this attachment in INPUT table.
Thanks a lot.
Sory use this one, wrong file...
Does it make sense if Column O & S will refer to column K as ID
That is not what i was asking. Columns O & S in the output section do not follow your request to compress their data upwards. There are blank cells above the data.
Further more in the latest workbook example from within the input section, Column O has the values 60,60,70,60 & 60. Where as the Output section only has the values 1 & 1. What happened to these values?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Hi Aussiebear,
Sorry for make it looks complicated, actually the output table hasn't tally with input table because I just want to show u the result looks like. I think to mae it easy, lets blanko value for column O,P,Q,R,S. Does it workable?