• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula to copy consecutive entries

KUNAL MITTAL

New Member
I ve the following entries:

S.nO. Name Place DOB Sex Quali Sign
1 ahf dhsd 12.11 male bcom left
2 aas kiyh 12.10 male bcom rt

How do I put it in the following seqence
S.No. 1
Name ahf
Place dhsd
DOB 12.11
SEx male
Quali bcom
Sign left

I know the formula

+e62
+f62
+g62

is there any other formula.
 
Assuming the following data layout you can use either Offset or Index to rearrange the values

upload_2015-3-3_14-26-58.png

Offset: =OFFSET($A$1,MATCH($H$7,$A$2:$A$3,0),ROWS($G$11:$G11))

Index: =INDEX($A$2:$G$3,MATCH($H$7,$A$2:$A$3,0),ROWS($I$11:I11)+1)

I'd recommend Index

see attached file:
 

Attachments

  • Offset Index example.xlsx
    9.5 KB · Views: 2
Hi Kunal,

Using @Hui file if you have only say less number of columns just another option using TRANSPOSE function. Note the function is multi cell array formula.

Regards,
 

Attachments

  • Offset Index example.xlsx
    9.6 KB · Views: 1
Back
Top