Data Organization

Question

Hello,

I have a sheet where I plan to upload data from a software and have excel organize the data. However, the sheet doesn’t look great with the IF statement formula all the way down the column. I would also like to edit the data once organized in the excel spreadsheet.

Wondering how I can do two things.

• Have the IF statement populate and stop down the column as data comes in.  I don’t want the formula to show up in the cell unless there is Output Data.
• Have the Output Data show up as text and not a formula. I would like to edit the Output data once the data is imported.

Thanks

Answer 1

Hi,

sql:

select * from Sheet1;

select iif(f01 like '',f02,f01) f01,f03,f04 from Sheet1;

f01	f02	f03	f04
10003		Remove Doors	-100
	5001	Add Windows	500
10560		Remove Cabinets	-600
15005		Remove Desk	-800
f01	f03	f04
10003	Remove Doors	-100
5001	Add Windows	500
10560	Remove Cabinets	-600
15005	Remove Desk	-800

Answer 2

Hi,

For Request 1, load the data into Power Query. Create a single column of Number and load that data back into the worksheet.

Answer 3

Hello,

Spreadsheet information:

Get data from a software and past it into the data input tab. The data output tab organizes the data.

Request 1:

On the data output, I don't want the empty cells to display the formula. however, if more data is inputted, I want the formula to continue down the column as needed.

Request 2:

Once the data is organized in data output tab, I would like to edit the text as needed. Is there a way to have the data input as text and not a formula?

Excel:

Data Input Tab

Number	Optional Number	Name	Cost
10003		Remove Doors	-100
	5001	Add Windows	500
10560		Remove Cabinets	-600
15005		Remove Desk	-800

Data Output Tab

Number	Name	Cost
10003	Remove Doors	-100
5001	Add Windows	500
10560	Remove Cabinets	-600
15005	Remove Desk	-800

Answer 4

Hi,

Share some data to work with and show the expected result. Share data in a format that can be pasted in an MS Excel file.