List items under different headings in one column in another sheet

[k9515]

The source list will be pasted into a sheet and one column will have a varying number of items each time. I need to map the items under each standard subheading to another sheet so Xlookups work. The rows will change so the headings location will be in different rows each time. The users need to be able to just paste in the sheet and move on. Possible? Thanks

Heading 1 XYZ Fee Commissioning PM Fee Consultant - Other Heading 2 ABC Fee Commissioning PM Fee Consultant - X Support Allowance Reimbursable Allowance

 

[k9515]

The source list will be pasted into a sheet and one column will have a varying number of items each time. I need to map the items under each standard subheading to another sheet so Xlookups work. The rows will change so the headings location will be in different rows each time. The users need to be able to just paste in the sheet and move on. Possible? Thanks

Heading 1 XYZ Fee Commissioning PM Fee Consultant - Other Heading 2 ABC Fee Commissioning PM Fee Consultant - X Support Allowance Reimbursable Allowance

Thinking it might help to share that the headings are always the same and in the same order.

 

[k9515]

Thinking it might help to share that the headings are always the same and in the same order.

Adding a better example in hopes someone has a solution.

 

[Sufiyan97]

Adding a better example in hopes someone has a solution.

Can you paste the data here instead of image?

 

[Sufiyan97]

Or see if this helps

Book1
	A	B	C	D
1	Heading	Accounts Description
2	Soft Cost	Soft Cost - CAP
3	Soft Cost	Words 1
4	Soft Cost	Words 2
5	Soft Cost	PM Fee
6	Soft Cost	Consultant - Other
7	Allowances	Allowances
8	Allowances	Words 1
9	Allowances	Words 2
10	Allowances	PM Fee
11	Allowances	Consultant - Other
12	Allowances	JLL FM Support Allowance
13	Allowances	Reimbursables Allowance
14
15	Soft Cost	Soft Cost - CAP
16	Soft Cost	Words 1
17	Soft Cost	Words 2
18	Soft Cost	PM Fee
19	Soft Cost	Consultant - Other
20	Soft Cost
21	Soft Cost
22	Allowances	Allowances
23	Allowances	Words 1
24	Allowances	Words 2
25	Allowances	PM Fee
26	Allowances	Consultant - Other
27	Allowances	JLL FM Support Allowance
28	Allowances	Reimbursables Allowance
29	Allowances
30	Allowances
31
Sheet1

Cell Formulas
Range	Formula
B15:B30	B15	=IFERROR(INDEX($B$2:$B$13,AGGREGATE(15,6,(ROW($B$2:$B$13)-ROW($B$2)+1)/($A$2:$A$13=$A15),COUNTIF($A$15:$A15,$A15))),"")

 

[k9515]

Can you paste the data here instead of image?

I tried, but had to download the mini-sheet app. I have a solution now. Will check to see if your solution works too.

 

[k9515]

This is a solution

=IF( COUNTIF(A$12:A12,A12)>COUNTIF(_Map2[Headings],A12),"",INDEX(_Map2[Account Description],MATCH(A12,_Map2[Headings],0)+COUNTIF(A$12:A12,A12)-1))

 

[k9515]

I tried, but had to download the mini-sheet app. I have a solution now. Will check to see if your solution works too.

Your solution also worked. Love it! Thank you, thank you!

 

[Sufiyan97]

You're welcome!