Easy for mrexcel, but so hard for me - sorting rows dependent on 1 column

[garfiola]

Hi, thank you for this forum it is a godsend, gosd bless you all

my question goes like this

I have the following fields


A1 B1 C1 D1 E1 D1 F1 G1


A1-D1 are ok,
A1 has similar data as E1 so I want to put same fields of E1 in the same row as A1 but D1 F1 G1 have to be locked with E1, they are dependant on E1

So I want to align E! plus D1, F!, G1 with A1 depending on A1 and E1 corellation

Thank you I hope you understand what I want

can somebody write me a code please, it is really important, I just don't get Excel, never good at math at school

 

[Smitty]

Welcome to the Board!

Can you post an example of what you have now and your desired outcome? If you check the link in my sig for the HTML maker you'll be able to do it.

 

[garfiola]

ok i downloaded your link but how to use it?

 

[Smitty]

There's a Word document in the same location that explains it.

 

[garfiola]

I installed it, i select the cells and generate html all formulas and I can't see the file that is generated, it does not ask me where to save it

can i upload the excel somewhere online?

 

[garfiola]

Here is the file

www.thaistore.org/mrexcel.csv

thank you for helping me, god bless you

 

[Smitty]

You don't need to save anything. As soon as you go through the HTML Maker steps it copies the code the clipboard. Then just come back here and paste, and post. The board software will automatically render the code for you.

We'll have to work on updating it so that it gives you a message that it's copied the sheet.

 

[garfiola]

Removed HTML Image - It was blowing up the page. You need to take smaller shots. Note that you can post multiple images on a page on top of each other. Moderator

 

[garfiola]

Ok I managed it, thank you, great plugin!

BAsically I want align in the same row A and AP column because they have same product id info, but AQ-AS are linked to AP column so they need to be moved with AP.

 

[p45cal]

Make a copy of the sheet, and on that copy delete the range AP2:AT8 (keeps the headers).
Then put the following formulae in AP2:AT2, and copy down. You shouldn't need to keep column AP since it's a duplicate of column A.
Then you can copy|paste-special|values in situ to lose the formulae.

Excel Workbook
	AP	AQ	AR	AS	AT
1	products_id	metatags_title	metatags_keywords	metatags_description
2	2	Sterling Silver	Sterling Silver	SterlingBarrette	desc3
3	3	Sterling Silver	Sterling Silver	SterlingBarrette	desc5
4	4	Sterling Silver	Sterling Silver	SterlingBarrette	desc2
5	5	Sterling Silver	Sterling Silver	SterlingBarrette	desc7
6	6	Sterling Silver	Sterling Silver	SterlingBarrette	desc4
7	7	Sterling Silver	Sterling Silver	SterlingBarrette	desc1
8	#N/A	#N/A	#N/A	#N/A	#N/A
Sheet