Transpose cells based on column containing particular value

[gavmer11]

Hi all,

First time poster!!

I have a data source containing transactional data. Users may input a project code.

If a user has input a project code, i would like that value to transpose beside the other information known as cost centre. The way data exports now, it drops down a row and i need a single row to contain all transaction data (see transaction reference).

In theory, if project code appears, transpose the cell beside it, and up one row. Workbook shows structure.

Hoping to keep it simple with a formula - thanks for all your help!!

Cheers

Gav

[shukla.ankur281190]

Try

C2

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Copy across

[AliGW]

You can't move data with a formula, as you seem to require. Using a formula, you can replicate the data where you want it, but not remove it from where it is currently, although you could do so later if you wanted to.

[gavmer11]

Hi!

If data only needed to be copied using a formula, is this possible?

[gavmer11]

Hi!!

Sorry, struggling to work out how to apply this - any chance you can show in the workbook?? Probably should have changed the sheet names.....

[JohnTopley]

On your data this works ..

=IF(A3=A2,C3,"")

See attached with Shukla's formula as well.