Help with inverting cell values

hello,

Can someone please help me with the following; I need a formula to do this for alot of data in my sheet

I have values under A1,B1,C1.

A1 B1 C1
Sam Tam Ram

I want to invert the result

A2 B2 C2
Ram Tam Sam

Is this possible please?

Thanks
Sam

How about

Formula:

Please Login or Register  to view this content.

Thank you so much.. this is good for what I was trying to do but it seems my rows never have 3 cell values only populated.

Here is an example:

Row 1:
A1 B1 C1
Sam Tam Ram

Row 2:
A1 B1 C1 D1
Sam Tam Ram Bam

What I am trying to say is, its not always A1, B1 and C1. this may have less or more than 3 cell values in a single row.

Is there a modification possible to your formula please?

Thank you,
Sam

How about

Formula:

Please Login or Register  to view this content.

Originally Posted by Fluff13

How about

Formula:

Please Login or Register  to view this content.

I think I am doing something wrong here. I am getting no return back from your formula, a "0".

A B C D
Name 1 Name 2 Name 3 Name 4 Your Formula Return
Ram Tam Sam 0 =LET(f,FILTER(A2:G2,A2:G2<>""),c,COLUMNS(f),INDEX(f,SEQUENCE(,c,c,-1)))
Ram Tam Sam Bam 0 =LET(f,FILTER(A3:G3,A3:G3<>""),c,COLUMNS(f),INDEX(f,SEQUENCE(,c,c,-1)))


Thanks
Sam

In that case can you upload a workbook that shows the problem.

excelforum.xlsx

Here you go, thanks again.

Thanks for that, the problem is you have a circular reference. Either change the formula to look at A2:F2, or move the formula to column H

Originally Posted by Fluff13

Thanks for that, the problem is you have a circular reference. Either change the formula to look at A2:F2, or move the formula to column H

All good now. Thank yo very much.

Glad to help & thanks for the feedback