Rows to Column

**grcshekar** · 08-08-2021, 06:21 AM

Hi,

Please refer attached sample data

I want to convert data in ORIGINAL to CONVERTED .

I have more than 10,000 addresses

**Czeslaw** · 08-08-2021, 04:31 PM

Formula
Mr.

Formula:

Please Login or Register  to view this content.

and

Formula:

Please Login or Register  to view this content.

**grcshekar** · 08-08-2021, 11:44 PM

This works only if title is Mr, Mrs.
How to modify for "Dr", "Col", "Lt.Col" Etc

**Czeslaw** · 08-09-2021, 06:48 AM

New formulas
1.

Formula:

Please Login or Register  to view this content.

2.

Formula:

Please Login or Register  to view this content.

**alansidman** · 08-09-2021, 09:26 AM

If you are willing to go down the Power Query Road, then the attached solves the problem. You do need to list your prefix titles in a separate table.

Re: Rows to Column