Can we do Spark DataFrame transpose or pivot without aggregation?

off course you can, but unfortunately, you can't achieve using Pivot function. However, pivoting or transposing DataFrame structure without aggregation from rows to columns and columns to rows can be easily done using Spark and Scala hack. please refer to stackoverflow example.