How to fill multiple cell one after another in one column refer to adjacent cell

[Ubaid ur Rahman]

In the table below you will see values so you can easily understand what I am asking for! This is what I have and which have no pattern in cells!

I want this as seen in the table below. I highlighted myself to show you what I have and what I want in the adjacent column!

Can anybody help me with this thing because I have to do it for thousand of rows and I do it manually until now.

Your quickly help and answers are appreciated.

[#2 · Accepted solution]

Hi

Use combined IF and LEN functions

=IF(LEN(B2)=9,A1,B2) ect

[#3]

Wow! thanks alottttt!!!!!

[#4]

Hi Tomasz,

how to deal with the following in table.

The formula worked until characters of supplier no was different that product no. but afterwards you find in the table given at the end product and supplier no are same in character.

Can you please help!

Thanks in advance!

[#5]

Hi Ubaid

 Please see the file

The best solution for that it could be to create a table with all suppliers number if you know them (or you can update every time if appears a new one)

=IF(COUNTIF(Table1[SupMatNr],B3),B3,A2)

I guess what you are trying to do, but first, I will have to see the source of the data, you can do that with the PivotChart Wizard, it is potentially the quicker way

[#6]

Hallo Tomasz,

I think its working now. Thanks alot!
Can you please explain a bit what can we do with PivotChart Wizard?

[#7]

Please read my post here and try applying to your data (ALT, D, P)

https://techcommunity.microsoft.com/t5/Formulas-and-Functions/Transposing-problem/m-p/182022#M4732

[#8]

Thank you for your help! :)