Report text spacing

Company	Equip	Time
ABC	AC	12:00
		01:00
BAC	FAN	13:00
		14:30
	Light	15:00
		17:00
CAB	FAN	23:00
	Light	01:30
	AC	02:30

This my data set where I want the data in word document when using the report text tool there is row gap could you please help me I dont want any row gaps.

The output should be in below format.

ABC

.12:00

.01:00

BAC

FAN

. 13:00

. 14:30

Light

.15:00

.17:00

CAB

FAN

.23:00

Light

.01:30

.02:30

Workflow

Parse

Transformation

Accepted answers

Maskell_Rascal

Hi @abhijeet_86

You can transpose your data and remove the row gaps. You won't be able to indent any fields using this method, so I added a formula tool at the beginning of the workflow to add the indents to get the desired formatting in the Report Text tool.

Try out this workflow and let me know if it works for you.

Thanks!

Phil

Report Text Spacing.yxmd

All comments

Maskell_Rascal

Hi @abhijeet_86

Try out this workflow and let me know if it works for you.

Thanks!

Phil

Report Text Spacing.yxmd

abhijeet_86

HI @Maskell_Rascal thanks for the solution need one more help i need to have bullet points in Time , however when I am adding it is really small wanted to have bold could not able to figure it out

PaulStark

How was the Bullet point issue solved? I'm trying to build a bulleted list in the Report tool, but I don't know how to create the different bullets for each level of the list. I have 5 layers that I need to differentiate between in the bullet list.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703