• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to combine multiple rows data into one row

Dear Sir,

Thank you for valuable ideas.....
it is very useful when we have small data...(like 50 or 100 line items....)
but if I have 1000 or 2000 line items so that time how I can sort it.....
 
Hi, Sunil Kukreti!
If I were you I'd go with Hui's suggestions and forget about formulas in this case.
Regards!
 
@Sunil Kukreti

Hui suggestion of getting unique values through advanced filter will be faster compared to my link method, as I had used formula, next putting values in cell will have to be macro.

SO go with Hui's suggestion.

Regards,
 
Back
Top