Reduce Rows with Data

**Vixx1** · 08-14-2019, 07:00 AM

Hello,
I've got problem with excel task. I need to compress rows for specific ID number ( its like 50k record). For 1 spec ID for now its 12 rows and I'd like to insert all this data to 1 row, for now i don't know how to solve this, please help me

**Kaper** · 08-14-2019, 11:42 AM

is expected output one very long row for each ID?
It wil be a) very tough to read b) even tougher to process

3 additional questions:
- will there be always 12 rows for each ID? or could it change - some ID's with less, or may be some with more rows?
- will start and end dates (columns B and C) have the same values within single ID?
- why do you put texts just looking as dates, not real excel dates in column B?

**Kaper** · 08-16-2019, 07:18 AM

Don't know why you cannot answer in the thread (as you reported in PM), but the solution could be such code:

Please Login or Register  to view this content.

Reduce Rows with Data

LinkBack

Thread Tools

Rate This Thread

Display

Reduce Rows with Data

Re: Reduce Rows with Data

Re: Reduce Rows with Data

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Reduce rows according to cell values

reduce row range in existing worksheet to reduce file size

[SOLVED] Reduce the number of rows in a spreadsheet

Reduce sheet to rows with certain value

Reduce number of rows and columns

[SOLVED] How do I reduce the no. of rows & columns in a worksheet ?

Reduce columns and rows count?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions