DQX |How can I make cell data automatically down as in Excel to align with other column values

[MYDATASTORY]

Hi

I have data in Excel and I am trying to use DAX or any easier way to mapulate data in Excel 

How can I make cell data automatically shift down  when adding space so I can match column D and column B values. The main column is Column D and I need to align the column on where I find the matching value on left side which can be from column A&B

Process:

Match column D with Column B by inserting blank cell so it will align  with column B

In Excel I will do insert and the shift cell down so it matches with column B or any column on the left  provided I can find that number I am looking from Column C, I will then just need to align this. I want to automate this.

Thanks in advance

 I have column A , B and C 

Column A	Column B	Column C	Column D
Number	ID1	Product	ID2
9	10	sugar	9
8	9	salt	8
9	9	cooking oil	7

[v-deddai1-msft]

Hi @MYDATASTORY ,

Would you please show us the expected output based on your sample data? I can't understand what's your need based on your description.

Best Regards,

Dedmon Dai

[pranit828]

Hi @MYDATASTORY 

You probably don't need a DAX and VLOOKUP would be an easier option.

[amitchandak]

@MYDATASTORY , matching number or alignment? can you please give example, what you want to match with what value?