HOw to delete blanks in a range and have one column be excluded

[EliteFx]

Hello,

I am losing it trying to figure out how to modify my CSV file. ANY HELP WOULD BE REALLY APPRECIATED!

I am trying to delete all the blanks in a range of columns and excluding a certain column.

For example: i.imgur.com/S8pUlh9.png

From the image above I want to remove all the blanks from column A to P and exclude the content (IMG links) from Column Q but remove the blanks under the image links that match the blanks from A to P that i removed.

Basically, I want to keep all the image source links in Column Q and have them shift to the next blank row in that column, so the images align to the title of the row.

Then I would like to use the CSV and upload it to a website that can pull all the data and images.

Really appreciate any help.

Thanks

[alansidman]

Hi and welcome to the forum

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.