VBA code to parse raw output report

[smide]

Hello.

I'm using the following code to parse my raw report from row1-Sheet2 and transfer data to Sheet1, creating this kind of table:

	O	P	Q	R
1
2	id	shop	store	factory
3	3456	23	15	25
4	3467	12	16	28
5	3468	24	19	33
6	...	...	...	...

Data in row1-Sheet2 are organized in the following pattern: id - shop - stor - fact

My problem is reflected in the fact that sometimes between the two id's there are no this "shop-stor-fact" cells which means that my prices are often in the wrong row in above table (next to the wrong id).

I would like to re-arrange this code so in the case that between the two id's there are no this cells which contains significant text (shop-stor-fact), then, in the table, that row stays empty.

example:

(id-shop-store-factory) (id-shop-store-factory) (id) (id-shop-store-factory) (id-shop-store-factory) ....

	O	P	Q	R
1
2	id	shop	store	factory
3	3456	23	15	25
4	3467	12	16	28
5	3468
6	3470	24	19	33
7	3471	27	11	39

Here is the code I used so far:

Please Login or Register  to view this content.

Here is a sample workbook:

[kalbasiatka]

Show a piece of the original data file. Similar to json.

[LeoTaxi]

Try this 1

Please Login or Register  to view this content.

Kind regards
Leo

[smide]

Try this 1

Please Login or Register  to view this content.

Kind regards
Leo

Thank you for reply and your effort, I really appreciate it.

I tested your code and indeed for example I posted everything works fine.
However, when I tested it on some more complex data code it always return id (id list) correct, but I have problem with prices output (missing or even doubled).

I've noticed that you have changed characters search lines in my second macro...
Maybe price output problem have something with this issue?
Please, look at example I've attached in my next post (Code2.xlsx)

[zbor]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[smide]

I've attached new complex example (with a bit changed specifications):